
Select	EN.EntityID, 
		EN.EntityName, 
		EN.UEN,
		CP.Salutation,
		CP.Name,
		CP.SurName,
		CP.Mobile,
		CP.Office,
		CP.OfficeExt,
		CP.Residential,
		CP.FaxLine,
		CP.Email
FROM tblEntity EN
INNER JOIN tblContactProfile CP ON EN.EntityID = CP.EntityID
Where Mobile LIKE '%988989%' OR Office LIKE '%988989%' OR Residential LIKE '%988989%' OR Email LIKE '%988989%' OR EntityName LIKE '%988989%' OR UEN LIKE '%988989%'


Select	EN.EntityID, 
		EN.EntityName, 
		EN.UEN,
		CP.Salutation,
		CP.Name,
		CP.SurName,
		CP.Mobile,
		CP.Office,
		CP.OfficeExt,
		CP.Residential,
		CP.FaxLine,
		CP.Email
FROM tblEntity EN
INNER JOIN tblContactProfile CP ON EN.EntityID = CP.EntityID
Where CONTAINS(Mobile, '"9889*"')

Declare @SearchKeyWord varchar(20)

SET @SearchKeyWord = 'phyo'
Select TOP 20	EN.EntityID, 
            CP.ContactProfileID,
		    EN.EntityName, 
		    EN.UEN,
		    CP.Salutation,
		    CP.Name,
		    CP.SurName,
		    CP.Mobile,
		    CP.Office,
		    CP.OfficeExt,
		    CP.Residential,
		    CP.FaxLine,
		    CP.Email
    FROM tblEntity EN
    INNER JOIN tblContactProfile CP ON EN.EntityID = CP.EntityID 
	Where (Mobile LIKE '%' + @SearchKeyWord + '%') OR (Office LIKE '%' + @SearchKeyWord + '%') OR Residential LIKE '%'